picaso

Tables (6)

Admin (CopyOfsex3)

  • admin_id (Key) — PK — Primary key — NOT NULL
  • admin_name (Field2) — unique
  • password (Field)

Answer (CopyOfsex)

  • answer_num (Key) — auto_increment — Primary key — NOT NULL
  • question_num (Key3) — auto_increment — Foreign key → Question.question_num — NOT NULL — AutoIncrement
  • admin_id (Key2) — forign_key — Foreign key → Admin.admin_id — NOT NULL
  • answer_content (Field2)
  • make_date (Field) — date

Notice (CopyOfsex2)

  • notice_num (Key) — auto_increment — Primary key — NOT NULL
  • admin_id (Key2) — forign_key — Foreign key → Admin.admin_id — NOT NULL
  • admin_name (Field2) — forign_key
  • notice_title (Field3)
  • notice_content (Field4)
  • make_date (Field) — date

Question (sex)

  • question_num (Key) — auto_increment — Primary key — NOT NULL — AutoIncrement
  • user_id (id) — forign_key — Foreign key → User.user_id — NOT NULL — 아이디
  • user_email (Field) — forign_key
  • views (Field2)
  • question_title (Field3)
  • question_content (Field4)
  • make_date (Field5) — date

Selling (CopyOfsex4)

  • selling_num (Key) — auto_increment — Primary key — NOT NULL
  • user_id (id) — forign_key — Foreign key → User.user_id — NOT NULL — 아이디
  • user_email (Field) — forign_key
  • user_nickname (Field3) — forign_key
  • views (Field2)
  • question_content (Field4)
  • Field5

User (Untitled)

  • user_id (id) — Primary key — NOT NULL — 아이디
  • password (pw) — unique — NOT NULL — 패스워드
  • user_name (name) — unique — NOT NULL — 이ㅣ름
  • user_nickName (Field) — unique — 닉네임
  • user_phnum (Field2) — unique
  • user_email (Field3)
  • permission (Field4)