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