likelion_Hackathon

Tables (6)

Assessment (assessment)

  • Assess No (assess_no) — INT(11) — Primary key — NOT NULL
  • work_no — VARCHAR(20)
  • Member No (member_no) — VARCHAR(20)
  • Assess St (assess_st) — TEXT
  • Assess Dt (assess_dt) — DATATIME

Board (board)

  • work_no (work_nb) — INT(12)
  • Work Nm (work_nm) — VARCHAR(20)
  • Keyword Nm (keywork_nm) — VARCHAR(20)
  • Work Intro (work_intro) — TEXT
  • End Work (end_work) — VARCHAR(20)
  • DateTime (datatime) — DATATIME
  • Open Mb (open_mb) — YN
  • Assessment (assessment) — YN
  • Cheer (cheer) — YN
  • Success (success) — YN
  • Success Story (success_story) — TEXT
  • Past Slip (past_slip) — TEXT

Keyword (keyword)

  • Keyword No (keyword_no) — INT(11)
  • Keyword Nm (keyword_nm) — VARCHAR(20)

Like (like)

  • work_no (gallery_no) — VARCHAR(20)
  • Member No (member_no) — VARCHAR(20)

Member Information (member_information)

  • Member No (member_no) — INT(11) — Primary key — NOT NULL
  • Member Id (member_id) — VARCHAR(20) — NOT NULL
  • Member Pwd (member_pwd) — VARCHAR(20)
  • Member Nm (member_nm) — VARCHAR(20)
  • Member_NK (member_nk) — VARCHAR(20)
  • Gallery Nm (gallery_nm) — VARCHAR(20)
  • Motto (motto) — VARCHAR(20)
  • Profile Pic (profile_pic) — VARCHAR(20)

Subscriber (subscriber)

  • Member Id (member_id) — VARCHAR(20)