Lime

Tables (9)

Artfile (artfile)

  • AFNUM (af_num) — INT — Primary key — NOT NULL
  • AFANUM (af_anum) — VARCHAR(30) — Foreign key → Artwrok.ANUM — NOT NULL
  • AFIMGORINAME (af_imgoriname) — VARCHAR(50)
  • AFIMGSYSNAME (af_imgsysname) — VARCHAR(50)
  • AFMUSICORINAME (af_musicoriname) — VARCHAR(50)
  • AFMUSICSYSNAME (af_musicsysname) — VARCHAR(50)

Artwrok (artwork)

  • ANUM (a_num) — INT — Primary key — NOT NULL
  • AID (Key) — VARCHAR(30) — Primary key — NOT NULL
  • ATITLE (a_title) — VARCHAR(20)
  • ACATEGORY (a_category) — VARCHAR(20)
  • AGENRE (a_genre) — VARCHAR(20)
  • APRICE (a_price) — INT
  • AGROUP (a_group) — VARCHAR(20)
  • APUBLISHER (a_publisher) — VARCHAR(50)
  • AAGENCY (a_agency) — VARCHAR(50)
  • ARELEASE (a_release) — VARCHAR(20)
  • ACONTENTS (a_contents) — VARCHAR(1000)
  • ADATE (a_date) — DATETIME
  • ACNT (a_cnt) — INT
  • ADEL (a_del) — BOOLEAN

Board (board)

  • BNUM (b_num) — INT — Primary key — NOT NULL
  • BID (b_id) — VARCHAR(30) — Primary key — NOT NULL
  • BTITLE (b_title) — VARCHAR(50)
  • BCONTENTS (b_contents) — VARCHAR(100)
  • BDATE (b_date) — DATETIME
  • BTYPE (b_type) — VARCHAR(10)

Grade (grade)

  • GCODE (gcode) — CHAR(1) — Primary key — NOT NULL
  • GNAME (gname) — VARCHAR(10)
  • GLOWPOINT (g_lowpoint) — INT
  • GHIGHPOINT (g_highpoint) — INT

Member (member)

  • MID (mid) — VARCHAR(30) — Primary key — NOT NULL
  • MPWD (mpwd) — VARCHAR(100)
  • MNAME (mname) — VARCHAR(10)
  • MKAKAO (mkakao) — VARCHAR(30)
  • MNICK (mnick) — VARCHAR(30)
  • MPOINT (mpoint) — INT
  • MTEXT (mtext) — VARCHAR(200)
  • MSECRET (msercret) — VARCHAR(50)

Message (message)

  • MNUM (m_num) — INT — Primary key — NOT NULL
  • MMID (m_mid) — VARCHAR(30) — Foreign key → Member.MID — NOT NULL
  • MANUM (a_num) — VARCHAR(30) — Foreign key → Artwrok.ANUM — NOT NULL
  • MTITLE (m_title) — VARCHAR(50)
  • MTEXT (m_text) — VARCHAR(500)
  • MDATE (m_date) — DATETIME
  • MRMID (m_rmid) — VARCHAR(30)
  • MFILEORINAME (m_fileoriname) — VARCHAR(50)
  • MFILESYSNAME (m_filesysname) — VARCHAR(50)
  • MISREAD (m_isread) — VARCHAR(10)
  • MPRICE (m_price) — INT
  • MISPAY (m_ispay) — BOOLEAN

Payment (payment)

  • PNUM (p_num) — INT — Primary key — NOT NULL
  • PPID (p_pid) — VARCHAR(30) — Foreign key → Member.MID — NOT NULL
  • PANUM (p_anum) — VARCHAR(30) — Foreign key → Artwrok.ANUM — NOT NULL
  • PBID (Key) — VARCHAR(30) — Foreign key → Artwrok.AID — NOT NULL
  • PDATE (p_date) — DATETIME
  • PPRICE (p_price) — INT

Reply (reply)

  • RNUM (r_num) — INT — Primary key — NOT NULL
  • RID (r_id) — VARCHAR(30) — Primary key — NOT NULL
  • RBNUM (b_num) — VARCHAR(30) — Foreign key → Board.BNUM — NOT NULL
  • RCONTENTS (r_contents) — VARCHAR(50)
  • RDATE (r_date) — DATETIME

Store (store)

  • SNUM (s_num) — INT — Primary key — NOT NULL
  • SID (s_id) — VARCHAR(30) — Foreign key → Member.MID — NOT NULL
  • SANUM (s_anum) — VARCHAR(30) — Foreign key → Artwrok.ANUM — NOT NULL