01
Tables (5)
bbs
- id — varchar(20) — Primary key — NOT NULL
- title (pw) — varchar(20)
- content — varchar(20)
- id (id2) — varchar(20) — Foreign key → member.id — NOT NULL
company
- id — varchar(20) — Primary key — NOT NULL — 회원id
- name — varchar(20)
- addr — varchar(20)
- tel — varchar(20)
member
- id — varchar(20) — Primary key — NOT NULL — 회원id
- pw — varchar(20)
- name — varchar(20)
- tel — varchar(20)
product
- id — varchar(20) — Primary key — NOT NULL — 회원id
- name — varchar(20)
- contentc (content) — varchar(20)
- price — varchar(20)
- company — varchar(20)
- img — varchar(20)
- id (id2) — varchar(20) — Foreign key → company.id — NOT NULL — 회원id
reply
- id — varchar(20) — Primary key — NOT NULL
- oriid — varchar(20)
- content — varchar(20)
- writer — varchar(20)
- id (id2) — varchar(20) — Foreign key → bbs.id — NOT NULL
- id (id3) — varchar(20) — Foreign key → member.id — NOT NULL — 회원id