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