mytest

Tables (8)

Untitled

    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