test2
Tables (7)
member (login)
- USER_ID (user_id) — varchar(20) — Foreign key → member.USER_ID — NOT NULL
- USER_ID2 (user_id2) — varchar(20) — Foreign key → member.USER_ID2 — NOT NULL
member (review)
- USER_ID2 (user_id2) — varchar(20) — Primary key — NOT NULL
- TITLE (title) — varchar(20)
- CONTENT (content) — varchar(255)
- IMG (img) — blob
member (admin)
- USER_ID (user_id2) — varchar(20) — Foreign key → member.USER_ID — NOT NULL
member (sign-up)
- USER_ID (user_id) — varchar(20) — Primary key — NOT NULL
- PASSWORD (password) — varchar(20)
- PASSWORD_CONFIG (password_config) — varchar(20)
- PHONE_NUMBER (phone_number) — varchar(14)
member (sign-up1)
- USER_ID1 (user_id) — varchar(20) — Primary key — NOT NULL
- PASSWORD (password) — varchar(20)
- PASSWORD_CONFIG (password_config) — varchar(20)
- PHONE_NUMBER (phone_number) — varchar(14)
- EMAIL (email) — varchar(255)
member (login1)
- USER_ID1 (user_id3) — varchar(20) — Foreign key → member.USER_ID1 — NOT NULL
- USER_ID02 (user_id2) — varchar(20) — Foreign key → review.USER_ID02 — NOT NULL
review (commiuncation)
- USER_ID02 (user_id2) — varchar(20) — Primary key — NOT NULL
- TITLE (title) — varchar(20)
- CONTENT (content) — varchar(255)
- IMG (img) — blob