Australian Speleological Federation KID: ASF Field Definitions

Article Tables

There are 2 sub-tables. Click on a sub-table below to see it's relationship with the master table for this entity.
AR0331 Authors    AR0333 Article comments   

AR0000: Articles   (925 rows of data)
FID Field Type Null Key Default Extra
307 article_id varchar(11) NO PRI
308 ref_year_of_publication varchar(4) YES
309 ref_suffix_to_year char(1) YES
335 ref_name_of_article varchar(132) YES
310 book_author_or_editor varchar(45) YES
311 ref_name_of_publication varchar(132) YES
312 ref_volume_number varchar(7) YES
313 ref_issue_number varchar(4) YES
314 book_publisher_and_city varchar(45) YES
315 page_range_or_quantity varchar(13) YES
316 bibliography_present char(1) YES
317 quantity_of_maps char(3) YES
318 quantity_of_plates char(3) YES
319 country_where_published char(2) YES
608 isbn varchar(10) YES
320 issn varchar(10) YES
321 state_supplying_this_ref char(1) YES
322 type_of_publication char(1) YES
323 local_abstract_year char(2) YES
324 local_abstract_category char(1) YES
325 local_abstract_reference varchar(4) YES
326 bbs_year char(2) YES
327 bbs_sequence_number varchar(5) YES
328 ssc_code char(3) YES
329 flag_if_surname_overflow char(1) YES



»------»
AR0331: Authors   (1055 rows of data)
FID Field Type Null Key Default Extra
307 article_id varchar(11) NO PRI
330 author_sequence smallint(6) NO PRI
331 author_surname varchar(20) YES
332 author_initials varchar(15) YES
Back to Top




[ ASF | KID | search | help | privacy ]