팀 프로 2
테이블 (5)
%_chat
- chat_seqno (Auto increment) — NOT NULL — 기본 키 — NOT NULL
- user_id — NOT NULL — 외래 키 → user.user_seqno — NOT NULL
- chat_txt — NULL
- chat_insertdate — NULL
- chat_inserttime — NULL
- chat_check — NULL
orders
- order_seqno (Auto increment) — NOT NULL — 기본 키 — NOT NULL
- order_pseqno (Auto increment2) — NOT NULL — 외래 키 → phone.phone_seqno — NOT NULL
- order_useqno (Auto increment3) — NOT NULL — 외래 키 → user.user_seqno — NOT NULL
- order_insert — NULL
- order_update — NULL
- order_delete — NULL
- order_address — NULL
- order_stock — NULL
phone
- phone_seqno (Auto increment) — NOT NULL — 기본 키 — NOT NULL
- phone_model — NULL
- phone_gb — NULL
- phone_color — NULL
- phone_cost — NULL
- phone_count — NULL
- phone_date — NULL
- phone_time — NULL
qna
- qna_seqno (Auto increment) — NOT NULL — 기본 키 — NOT NULL
- qna_id — NULL — 외래 키 → user.user_seqno — NOT NULL
- qna_title — NULL
- qna_txt — NULL
- qna_date — NULL
- qna_time — NULL
- qna_status — 1
- qna_oriseq — NULL
- qna_answer — 0
- qna_answerori — NULL
user
- user_seqno (Auto increment) — NOT NULL — 기본 키 — NOT NULL
- user_id — NULL
- user_pw — NULL
- user_telno — NULL
- user_address — NULL
- user_update — NULL
- uesr_deletdate — NULL
- user_inout — NULL