Danmoon
Tables (4)
writer_mem
- mem_idx — int(11) — Primary key — NOT NULL
- mem_email — varchar(60) — NOT NULL
- mem_pwd — varchar(200) — NOT NULL
- mem_nickname — varchar(30) — NOT NULL
- mem_type — varchar(20) — NOT NULL
- mem_regdate — datetime — NOT NULL
- mem_update — datetime — NOT NULL
writer_post
- p_idx_pk — int(11) — Primary key — NOT NULL
- p_mem_idx_fk — int(11) — Foreign key → writer_mem.mem_idx — NOT NULL
- p_material_idx_fk — int(11) — Foreign key → writer_post_materiallist.material_idx_pk
- p_material — varchar(100) — NOT NULL
- p_content — varchar(5000) — NOT NULL
- p_regdate — datetime — NOT NULL
- p_update — datetime — NOT NULL
- p_public — varchar(20) — NOT NULL
- p_likeit — int(11) — NOT NULL
- p_hit — int(11) — NOT NULL
writer_post_materiallist
- material_idx_pk — int(11) — Primary key — NOT NULL
- material_title — varchar(20) — NOT NULL
- material_distribute_date — date
- material_distribute_time — time
- material_regdate — datetime
- material_update — datetime
writer_subscribe
- s_idx_pk — int(11) — Primary key — NOT NULL
- s_memidx_fk — int(11) — Foreign key → writer_mem.mem_idx — NOT NULL
- s_subsmemidx_fk — int(11) — Foreign key → writer_mem.mem_idx — NOT NULL
- s_regdate — datetime — NOT NULL