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)