CMARKET_TEST
Tables (14)
auto_login_tb (Untitled13)
- Key — Primary key — NOT NULL
block_tb (Untitled5)
- blocker (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL
- blocked (Key22) — number — Foreign key → profile_tb.user_sq — NOT NULL
board_content_tb (Untitled2)
- board_content_sq (Key) — number — Primary key — NOT NULL
- board_sq (Key2) — number — Foreign key → board_tb.board_sq — NOT NULL
- board_content (Field) — varchar2(4000) — NOT NULL
board_tb (Untitled7)
- board_sq (Key) — number — Primary key — NOT NULL
- board_category (Key2) — varchar2(100) — Foreign key → category_tb.cate_sq — NOT NULL
- board_writer (Key3) — varchar2(100) — Foreign key → profile_tb.profile_sq — NOT NULL
- board_title (Field) — varchar2(255) — NOT NULL
- price (Field3) — number — NOT NULL
- board_img (Field4) — varchar2(255) — NOT NULL
- board_dips_cnt (Field9) — number — NOT NULL
- board_chat_cnt (Field10) — number — NOT NULL
- board_views_cnt (Field12) — number — NOT NULL
- board_date (Field11) — date — NOT NULL
- board_update_date (Field2) — TIMESTAMP — NOT NULL
- board_address (Field5) — VARCHAR2(100) — NOT NULL
- nego (Field6) — VARCHAR2(2) — NOT NULL
- board_state (Field7) — VARCHAR2(2) — NOT NULL
- board_sample4_jibunAddress (Field8) — VARCHAR2(100) — NOT NULL
- profile_sq (Key4) — number — Foreign key → profile_tb.profile_sq — NOT NULL
category_tb (Untitled6)
- cate_sq (Key) — number — Primary key — NOT NULL
- cate_name (Field) — varchar2(100) — NOT NULL
chat_header_tb (Untitled10)
- id (Key3) — number — Primary key — NOT NULL
- from_id (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL
- to_id (Key22) — number — Foreign key → profile_tb.user_sq — NOT NULL
- receiver (Field) — number — NOT NULL
- title (Field2) — varchar2(127) — NOT NULL
- status (Field3) — varchar2(20) — NOT NULL
- date (Field4) — date — NOT NULL
chat_message_tb (Untitled14)
- id (Key) — number — Primary key — NOT NULL
- header_id (Key3) — number — Foreign key → chat_header_tb.id — NOT NULL
- is_from_sender (Field) — varchar2(100) — NOT NULL
- content (Field2) — varchar2(2000) — NOT NULL
- read (Field3) — varchar2(20) — NOT NULL
- date (Field4) — date — NOT NULL
dips_tb (Untitled8)
- profile_sq (Key3) — number — Foreign key → profile_tb.profile_sq — NOT NULL
- board_sq (Key) — number — Foreign key → board_tb.board_sq — NOT NULL
file_tb (Untitled12)
- file_sq (Key) — number — Primary key — NOT NULL
- board_content_sq (Key2) — number — Foreign key → board_content_tb.board_content_sq — NOT NULL
- file_name (Field) — varchar2(255) — NOT NULL
- file_org_name (Field2) — varchar2(255) — NOT NULL
- file_size (Field3) — number — NOT NULL
follow_tb (Untitled4)
- follower (Key) — number — Primary key — NOT NULL
- leader (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL
profile_comment (Untitled3)
- comment_sq (Key) — number — Primary key — NOT NULL
- profile_sq (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL
- com_judge (Field2) — VARCHAR(1) — NOT NULL
- com_writer (Field4) — varchar2(100) — NOT NULL
- com_writer_sq (Field6) — NUMBER
- com_img (Field5) — varchar2(255) — NOT NULL
- com_content (Field3) — varchar2(1000) — NOT NULL
- com_date (Field) — date — NOT NULL
profile_tb (Untitled11)
- profile_sq (Key) — number — Primary key — NOT NULL
- user_sq (Key2) — number — Foreign key → user_tb.user_sq — NOT NULL
- profile_nickname (Field) — VARCHAR2(100) — NOT NULL
- profile_gender (Field2) — VARCHAR2(1) — NOT NULL
- profile_photo (Field3) — VARCHAR2(255) — NOT NULL
- profile_temperature (Field4) — NUMBER — NOT NULL
- profile_date (Field5) — DATE — NOT NULL
tag_tb (Untitled9)
- profile_sq (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL
- tag_name (Field) — varchar2(20) — NOT NULL
user_tb (Untitled)
- user_sq (Key) — number — Primary key — NOT NULL
- user_id (Field) — varchar2(100) — NOT NULL
- user_pwd (Field2) — varchar2(255) — NOT NULL
- user_name (Field3) — varchar2(255) — NOT NULL
- email (Field6) — varchar2(255) — NOT NULL
- phone (Field7) — varchar2(255) — NOT NULL
- address (Field4) — VARCHAR2(255) — NOT NULL
- sample4_postcode (Field5) — VARCHAR(25) — NOT NULL
- sample4_roadAddress (Field8) — VARCHAR(100) — NOT NULL
- sample4_jibunAddress (Field9) — VARCHAR(100) — NOT NULL
- sample4_detailAddress (Field10) — VARCHAR(100) — NOT NULL
- user_status (Field11) — VARCHAR2(1) — NOT NULL