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