rideonmusic
Tables (10)
article
- article_no — INT
- subject — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- hit — INT
- register_time — DATETIME
- member_id — VARCHAR(255) — NOT NULL
attraction_description
- content_id — INT — Primary key — NOT NULL
- homepage — VARCHAR(100)
- overview — VARCHAR(10000)
- telname — VARCHAR(45)
attraction_detail
- content_id — INT — Foreign key → attraction_description.content_id — NOT NULL
- cat1 — VARCHAR(3)
- cat2 — VARCHAR(5)
- cat3 — VARCHAR(9)
- created_time — VARCHAR(14)
- modified_time — VARCHAR(14)
- booktour — VARCHAR(5)
attraction_info
- content_id — INT — Foreign key → attraction_description.content_id — NOT NULL
- content_type_id — INT
- title — VARCHAR(100)
- addr1 — VARCHAR(100)
- addr2 — VARCHAR(50)
- zipcode — VARCHAR(50)
- tel — VARCHAR(50)
- first_image — VARCHAR(200)
- first_image2 — VARCHAR(200)
- readcount — INT
- gugun_code — INT
- latitude — DECIMAL(20,17)
- longitude — DECIMAL(20,17)
- mlevel — VARCHAR(2)
- sido_code2 — INT — NOT NULL
comments
- comment_id — INT
- parent_id — INT — 댓글을 단 댓글의 번호, 최초 댓글은 null
- group_id — INT — 최초 댓글로 묶인다.
- depth — INT — NOT NULL — 댓글의 댓글을 달 때마다 1씩 증가
- comment_order — INT — NOT NULL — (사실 필요없다)
- comment — TEXT — NOT NULL — EXT NOT NUL
- regist_time — DATETIME
- modify_time — DATETIME
- article_no — INT
- member_id — VARCHAR(255) — NOT NULL
gugun
- gugun_name — VARCHAR(30) — Primary key — NOT NULL
- gugun_code — INT
- sido_code2 — INT — NOT NULL
member
- member_id — VARCHAR(255) — Primary key — NOT NULL
- id — INT
- member_name — VARCHAR(255) — NOT NULL
- member_pwd — VARCHAR(255) — NOT NULL
- member_email — VARCHAR(255) — NOT NULL
- member_status — INT — NOT NULL — 0:비활성화, 1:회원, 2:관리자
- salt — VARCHAR(255)
planner
- plan_no — INT — Primary key — NOT NULL — auto_increment
- member_id — VARCHAR(255) — NOT NULL
- plantitle — VARCHAR(255) — NOT NULL
- schedule — varchar(255)
- transport — varchar(255)
- register_time — DATETIME
- Field — VARCHAR(255)
- member_id2 — VARCHAR(255) — NOT NULL
planner_sub
- plan_sub_id — INT — auto_increment
- plan_no — INT — NOT NULL
- content_id — INT — NOT NULL
sido
- sido_code — INT — Primary key — NOT NULL
- sido_name — VARCHAR(30)