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