mytest
Tables (8)
account
- account_id — varchar(50) — Primary key — NOT NULL
- account_user_id
- password
- name
- address1 (Field)
- address2 (Field2)
- zipcode (Field3)
- created_date
- created_by
- last_modified_date
- last_modified_by
- use_yn
bbs
- bbs_id — Primary key — NOT NULL
- user_id — Foreign key → account.account_id — NOT NULL
- bbs_type_id — Foreign key → bbs_type.bbs_type_id — NOT NULL
- title
- content
- layer
- parent_id
- created_date
- created_by
- last_modified_date
- last_modified_by
- use_yn
bbs_file
- bbs_file_id — Primary key — NOT NULL
- bbs_id — Foreign key → bbs.bbs_id — NOT NULL
- original_name
- name
- file_type
- file_size
- path
- use_yn
bbs_type
- bbs_type_id — Primary key — NOT NULL
- name
- row
- page
- created_date
- created_by
- last_modified_date
- last_modified_by
- use_yn
reply
- reply_id — Primary key — NOT NULL
- bbs_id — Foreign key → bbs.bbs_id — NOT NULL
- content
- parent_id
- layer
- created_date
- created_by
- last_modified_date
- last_modified_by
- use_yn
role
- role_id — Primary key — NOT NULL
- role_tyepe
role_user
- role_id — Foreign key → role.role_id — NOT NULL
- user_id — Foreign key → account.account_id — NOT NULL