팀 프로 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