test

Tables (6)

address (주소)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → user.id — NOT NULL
  • title (Field) — varchar(15)
  • distance (Field2) — INT
  • created (Field3) — datetime

comment (댓글)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (FK) — INT — Foreign key → user.id — NOT NULL
  • topic_id (FK2) — INT — Foreign key → topic.id — NOT NULL
  • description (Field) — text — NOT NULL
  • created (Field2) — datetime — NOT NULL

dormant (휴면자)

  • user_id (Key) — INT — Primary key — NOT NULL
  • id (Key2) — INT — Foreign key → user.id — NOT NULL
  • date (Field) — datetime — NOT NULL

topic (글)

  • id (Key) — INT — Primary key — NOT NULL
  • title (Field) — varchar(15) — NOT NULL
  • description (Field2) — text — NOT NULL
  • created (Field3) — datetime
  • product (Field4) — text
  • price (Field5) — INT
  • view (Field6) — INT
  • location (Field7) — varchar(20)

user (사용자)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — varchar(15) — NOT NULL
  • manner (Field2) — double — NOT NULL
  • created (Field3) — datetime — NOT NULL
  • number (Field4) — varchar(15)
  • location (Field5) — varchar(50) — NOT NULL
  • profile (Field6) — text
  • req (Field7) — double
  • retrade (Field8) — double

write (작성)

  • user_id (Key) — INT — Foreign key → user.id — NOT NULL
  • topic_id (Key2) — INT — Foreign key → topic.id — NOT NULL
  • created (Field3) — datetime